UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vFyK7XvouxZYH4uOQOkJm2lyUnsGWTNUj0uSLqnfBTk='
WHERE
key_id = 'e165ef5a817f69c89c6303cbad85848c9ed42794888f8a47a6f280d2dbbcf557'
AND (
token = 'vFyK7XvouxZYH4uOQOkJm2lyUnsGWTNUj0uSLqnfBTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)