UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X12gEXeYw5w+pZLW2OyBcvYrgIlv1HArWINuV8xVa24='
WHERE
key_id = '033f00aa3222c1dbf0202cd6f3eeaab00dcdf784c10bc56234c38a4119a52421'
AND (
token = 'X12gEXeYw5w+pZLW2OyBcvYrgIlv1HArWINuV8xVa24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)