UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ck7sgtaoZLQFahxCWqccQQNlRndXB68pCSAMObjwMnc='
WHERE
key_id = '3166b4f156b0acfa59e6b5bffe35a66c981afcacfcd07055c5fcbaf20402a097'
AND (
token = 'ck7sgtaoZLQFahxCWqccQQNlRndXB68pCSAMObjwMnc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)