UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YPiaSaRAFbTzkRFNecg7RW4Vik6FUU8rPl18ezmgJCI='
WHERE
key_id = '1a728a34b3c0f5a3ed85c783ac3f80d9ac3b59de0a0b318cfe4a07061d774560'
AND (
token = 'YPiaSaRAFbTzkRFNecg7RW4Vik6FUU8rPl18ezmgJCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)