UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pGlOO+57l6MVjCnc4AGykAOfb9LLF5rOI261mD1NYRY='
WHERE
key_id = 'a9f8952134aaa83d02793c9a0896066cf835da210f1857c8f4a3aead9bb9f8db'
AND (
token = 'pGlOO+57l6MVjCnc4AGykAOfb9LLF5rOI261mD1NYRY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)