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