UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mX1OEMuLVyGfCQ18TCg+gZtiYdIS72ckd5FgSfVq0Tk='
WHERE
key_id = 'd9f2dea9a1ab39c43df2b42e4fde495548b21d26f34bc89561ef93b068145628'
AND (
token = 'mX1OEMuLVyGfCQ18TCg+gZtiYdIS72ckd5FgSfVq0Tk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)