UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EeFrdg4FzwNoY9znOoTzEVef/qgdqLUy5fJjjg2GYhU='
WHERE
key_id = 'db07db86a5fc1547cd8b0c2f15b91a74d0af1c574c2e8d10084b2e5a4df87f71'
AND (
token = 'EeFrdg4FzwNoY9znOoTzEVef/qgdqLUy5fJjjg2GYhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)