UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TNZPEUWSOdCZTIM8Rxdt/s7TEhf1QFIA72ZHXvvSikE='
WHERE
key_id = 'f738d5c668b8675ae7eb1afeedd9e45e1b5e54aa94f98a5190b667c1223b48a2'
AND (
token = 'TNZPEUWSOdCZTIM8Rxdt/s7TEhf1QFIA72ZHXvvSikE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)