UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'orW7t482owGOxHtlRAYdQ6/i4StzMLFZ9ks3lfCTQVE='
WHERE
key_id = 'f2e4f91250da023254036eba43f1ed531aa43f4e9162784d75ea70dd62297fb3'
AND (
token = 'orW7t482owGOxHtlRAYdQ6/i4StzMLFZ9ks3lfCTQVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)