UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QJ+9t4Rw8Z34pxaVxygkkALdx1pFpxZnm3XGGK2RSLA='
WHERE
key_id = 'a6aa4e99015132c515ba22aa9d457b3fd4e713805370ed0f511e2ad9421ebd61'
AND (
token = 'QJ+9t4Rw8Z34pxaVxygkkALdx1pFpxZnm3XGGK2RSLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)