UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4LfU2jgZ3C1unlFaJCAjGEngwCcDI8CmfTXRXjn43fQ='
WHERE
key_id = 'd1a6878086fc6f365211ea7f73a5d8e50ebea92e26dbf1d20df54924c278ba80'
AND (
token = '4LfU2jgZ3C1unlFaJCAjGEngwCcDI8CmfTXRXjn43fQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)