UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LBQBc+vhVg7U7tMKzq7hCfEqQlsnHhQec1CWcu5zfho='
WHERE
key_id = 'b822b125ae0d2a6c5f341a75643b3298ef0093def7ca5679b9e2ac3725486a77'
AND (
token = 'LBQBc+vhVg7U7tMKzq7hCfEqQlsnHhQec1CWcu5zfho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)