UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8W6+3Lf2cwCtW+IDfNEUEddKyFCQtDo1xwOp6g0eiIA='
WHERE
key_id = 'd9c39c56915326b2bcfed7d3c7dc3c642f588f463249658b13682fbeb71c7fc0'
AND (
token = '8W6+3Lf2cwCtW+IDfNEUEddKyFCQtDo1xwOp6g0eiIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)