UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3gM0iSCjb9yrSLyv3h1pTDBgKC/QXPLQM0zAUbIsqMk='
WHERE
key_id = '09f7289dabe69a67d07f8fa0759f6c0ea9d0842e3bd38b68935b6d859ea819f1'
AND (
token = '3gM0iSCjb9yrSLyv3h1pTDBgKC/QXPLQM0zAUbIsqMk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)