UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5HE8Ix1tgt74aFnbiLU6oyGs5BM6/tLREElAdlnYQYc='
WHERE
key_id = '6b101be7527f9eeca6d3c52dfa84fb8a34628544a396d733e036e40672a0681c'
AND (
token = '5HE8Ix1tgt74aFnbiLU6oyGs5BM6/tLREElAdlnYQYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)