UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f9RXTSs/F+1asKm2wqE5576ywhX/6JIXiq51YFz21kI='
WHERE
key_id = 'cdcfe7ecfd806177b1df58a8b72a47a0883963b9d47fcf00ca297fe6d029c7c4'
AND (
token = 'f9RXTSs/F+1asKm2wqE5576ywhX/6JIXiq51YFz21kI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)