UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZLzoxC5qvFdhSFTP+6Tyw96Xqwcz5hWOiil7kwzPp/A='
WHERE
key_id = 'e84f8fd27fb28b348fd6d2c45d7294c10e2734e04b3cf855014efc98f442ccab'
AND (
token = 'ZLzoxC5qvFdhSFTP+6Tyw96Xqwcz5hWOiil7kwzPp/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)