UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '01Lc9gr9JuvAv5066uUEGsj0rf9qfz6jGVTBE7orTr0='
WHERE
key_id = 'f7afc7c18ea161e92f7d1e26e6144f86940db697a64d077ac12527bda6675a9a'
AND (
token = '01Lc9gr9JuvAv5066uUEGsj0rf9qfz6jGVTBE7orTr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)