UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YGQ2j/sCipyHJgkc7j+pdS2Uk6jQkM+GL5t7HHVkGM8='
WHERE
key_id = '9f02b8878ae000ebb3a827edae97a3797f1712a23f47e59be4a2b4b8bf399ccc'
AND (
token = 'YGQ2j/sCipyHJgkc7j+pdS2Uk6jQkM+GL5t7HHVkGM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)