UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BaFZFtHXsZO+pVfvb2H4FnqJG8S83P1XMNWqPkPIOwo='
WHERE
key_id = '8678a7d0995739047664264ffe26899f3d7993723ceb0c62cd0b1cb069c5255c'
AND (
token = 'BaFZFtHXsZO+pVfvb2H4FnqJG8S83P1XMNWqPkPIOwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)