UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PNG5HAA892V1yd4zANqz9eiKyYC1n76srdAb/2zUpwE='
WHERE
key_id = '720c93a7ee2500bcb688036f5bf59783b16fa96fdb939167034fca0ce055f489'
AND (
token = 'PNG5HAA892V1yd4zANqz9eiKyYC1n76srdAb/2zUpwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)