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