UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9jo+p4oLy3HX1K/2jIqqVY/btob2MisMIyMa2DEhXRE='
WHERE
key_id = '478b685fe5a4f9aab6e89a83a1f0f541a8adc055e835a2bff5389bfb776539a5'
AND (
token = '9jo+p4oLy3HX1K/2jIqqVY/btob2MisMIyMa2DEhXRE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)