UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0kJuTR+VQiUuUeMMwosjms9C0FpbM409AnL87t8/KjI='
WHERE
key_id = '27c19ab1cf6869dc9350927338e3b0627c2688cfdc4e816156161e5fb9e2f420'
AND (
token = '0kJuTR+VQiUuUeMMwosjms9C0FpbM409AnL87t8/KjI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)