UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '02k96Q033hokSbTPKdkMVMMUsl4tf00Wew9dlIKnVDI='
WHERE
key_id = '93cc1cd121f10000a5f67580b08661989af1e17e526488ff5d93bf554aa77fc9'
AND (
token = '02k96Q033hokSbTPKdkMVMMUsl4tf00Wew9dlIKnVDI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)