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