UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mj1j+kAg41i4QZQQln1+7f5ueChNnikI+Y/E8ZzYXQc='
WHERE
key_id = 'e16ea05e441846cda2ea680c974ba44dc14e7bfe6cfc4b8abf24305da0a28dba'
AND (
token = 'mj1j+kAg41i4QZQQln1+7f5ueChNnikI+Y/E8ZzYXQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)