UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BN+MmglATpTy5aIIwKIoJKxq79nfSezQeMqx/Vu7di4='
WHERE
key_id = 'a231cc1c146c00a37216c4828e25e727cec3d39bbfab92bdd1ac1623a337223f'
AND (
token = 'BN+MmglATpTy5aIIwKIoJKxq79nfSezQeMqx/Vu7di4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)