UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RiwqZ0kdN9pPIEbtgsrJOKKSYiqwTBXsIqJDKTxB5zk='
WHERE
key_id = '3e87b65aa4a827f43ee0c176c0bf62310af2cdcc3b7befd9dffbee12958d65d1'
AND (
token = 'RiwqZ0kdN9pPIEbtgsrJOKKSYiqwTBXsIqJDKTxB5zk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)