UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RziBz5eACTo1OxlNCip0tBvm5YJeZtEY6x4t+baxirw='
WHERE
key_id = '2de5aca5968dbd75dc24f9b7d7d3c1eb25317d0e7bdad9e42ae0df3d1a4d27f9'
AND (
token = 'RziBz5eACTo1OxlNCip0tBvm5YJeZtEY6x4t+baxirw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)