UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R8p9U8SB8ImeZ5MIFOOrMXBluuBQIsfBWgPzcAjMna4='
WHERE
key_id = '413a3ca3208a8dc94e070fda0b3d065f028b57711ff4561e64c1c8815dfb63ac'
AND (
token = 'R8p9U8SB8ImeZ5MIFOOrMXBluuBQIsfBWgPzcAjMna4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)