UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XIgnA7zLg5lTCOGTO832Hwl98/KPMnQjlvSk7LjY5j8='
WHERE
key_id = '5050862bb1f38c9e6e806698e71ac7067fdadcd4c18d0082ffc4f5cfaf37d94a'
AND (
token = 'XIgnA7zLg5lTCOGTO832Hwl98/KPMnQjlvSk7LjY5j8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)