UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JWFI97++uVL8MBbi25+pj9BP0+pnJzH4VD3t9B0VOrY='
WHERE
key_id = '27ed1914316e207d8e7b977f727a1a2ffe2589f5c012b934602028d15940b4b7'
AND (
token = 'JWFI97++uVL8MBbi25+pj9BP0+pnJzH4VD3t9B0VOrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)