UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I9o2KtX0vXbDx/13qhcn8u3xm1RzKBvIjAeKQDNc5pA='
WHERE
key_id = 'bc830d4377e91af6ea1b140ea3fb20d00b316afec872ed65185c88bdb22a7735'
AND (
token = 'I9o2KtX0vXbDx/13qhcn8u3xm1RzKBvIjAeKQDNc5pA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)