UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3E4oVMme6at4V2jnkpW2nvvsV0OUyKw7q7XvwTtl4Mk='
WHERE
key_id = 'a5b0c69df91fd08d3b0eaabaa0605a40929b9756e56ef24420779ea2ae5398ef'
AND (
token = '3E4oVMme6at4V2jnkpW2nvvsV0OUyKw7q7XvwTtl4Mk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)