UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LBGag+4+sv5KXK9+yGJzPEwg02ZdhwoT7biS3uKDblA='
WHERE
key_id = '58a041a8938107da34cac31be047b38bafeacc8ffe26bf7cf89ec453de944c9a'
AND (
token = 'LBGag+4+sv5KXK9+yGJzPEwg02ZdhwoT7biS3uKDblA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)