UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3P/tfbTmZ+Q9MiSLHYVOl+N9RkzoSXXA4kFXtB5B3Io='
WHERE
key_id = '0dfe742ebcfa2e058dcccf840c78aa4c81adb72e0785b989322812e1b330cf88'
AND (
token = '3P/tfbTmZ+Q9MiSLHYVOl+N9RkzoSXXA4kFXtB5B3Io='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)